NESUG 2004 - HW06: Clinical Trial Data Validation: Using SAS PROC SQL Effectively
================================================================

This workshop explores the PROC SQL features in the form of examples from clinical data
validation perspective. 

Your Workshop Materials can be found in  
	C:\workshops\HW06\
		- Paper
		- Programs	
		- DB

The following programs can be found in programs folder:

	hw06 - 00 Database Creation
	hw06 - 01 Select Statement
	hw06 - 02 CREATE TABLE Statement
	hw06 - 03 Adding Data to an Existing Table
	hw06 - 04 Dropping an Existing Table
	hw06 - 05 Deleting Rows From Table
	hw06 - 06 Using VALIDATE statement
	hw06 - 07 Using ALTER TABLE Statement
	hw06 - 08 Updating Existing Records
	hw06 - 09 Clinical Data Validation

The program hw06 - 00 program is included in rest of the programs which creates the required
clinical trial data base, the data base contains demog, endstudy, entcrit, medhx and vitals 
tables. The rest of the programs, hw06 - 01 to hw06 - 08, helps in knowing different PROC SQL
statements. The program hw06 - 09 contains a few examples of clinical data validation checks.

Programs can be best viewed, with proper indentation, in SAS enhanced editor.

Refer to the hw06.PDF file that contains the explanations for each of  the exercise mentioned in
the programs. 

Have fun in learning PROC SQL!!!

Your comments and questions are valued and encouraged. Contact the author at:

Balakrishna Dandamudi
Senior SAS Programmer
SFBC New Drug Services
Work Phone: 610.444.4722	
E-mail: kdandamudi@sfbci.com